Upper, Lower, & Proper

There are a few other functions that you will find useful if, for instance, you are using a file in which you want all of the letters to be uppercase letters or lower case letters.  Lets look at these functions using the Funexam worksheet.  Click on the Text tab in this work sheet.

Under the text tab you will see in column A names of many people.  If you wanted these names to appear in all uppercase letters you would use the upper function to convert them.  

Skill Builder:  Using the Upper Function 

1.	Click 	In the Cell where you want the newly formatted names 
		to appear.

2.	Type	The Function.  In this case the function is 
		
		=upper(cell address of value you want to appear in all 
		uppercase letters)

		For example, if you wanted to change the text in cell A2 
		to all uppercase letters, you would use the formula:  
		=upper(A2

3.  	Press	Enter.  When you press enter the text will appear in 
		uppercase letters.

The lower function works like the upper function, except that it will convert all letters to the lowercase letters.

Skill Builder:  Using the Lower Function 

1.	Click 	In the Cell where you want the newly formatted text to 
		appear.

2.	Type	The Function.  In this case the function is 
		
		=lower(cell address of value you want to appear in all 
		lowercase letters)

		For example, if you wanted to change the text in cell 
		A2 to all lowercase letters, you would use the formula:  
		=lower(A2

3.  	Press	Enter.  When you press enter the text will appear in 
		lowercase letters.

Another function, the proper function, will convert text to a more standard format.  If you have a group of names that appeared in uppercase letters, the standard function can be used to convert the names so that only the first letter of each name is capitalized, while the remainder of the letters will appear as lowercase letters.

Skill Builder:  Using the Proper Function 

1.	Click 	In the Cell where you want the newly formatted names 
		to appear.

2.	Type	The Function.  In this case the function is 
		
		=proper(cell address of value you want to appear in a 
		standard format)

		For example, if you wanted to change the text in cell 
		A2 from all uppercase letters to the proper format, you 
		would use the formula:  
		=proper(A2

3.  	Press	Enter.  When you press enter the text will appear in a 
		standard format.